﻿CREATE TABLE [dbo].[SiteCollection_RecyclelBin] (
    [RecycleBinID]     UNIQUEIDENTIFIER NOT NULL,
    [SiteCollectionID] UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_SiteCollection_RecyclelBin] PRIMARY KEY CLUSTERED ([RecycleBinID] ASC, [SiteCollectionID] ASC),
    CONSTRAINT [FK_SiteCollection_RecyclelBin_RecycleBin] FOREIGN KEY ([RecycleBinID]) REFERENCES [dbo].[RecycleBin] ([RecycleBinID]),
    CONSTRAINT [FK_SiteCollection_RecyclelBin_SiteCollection] FOREIGN KEY ([SiteCollectionID]) REFERENCES [dbo].[SiteCollection] ([SiteCollectionID])
);

